<?php
//模型
class UserSportModel extends MY_Model {
	function __construct(){
		parent::__construct();
		$this->table = 'user_sport';
	}
	//分页列表
	function get_list($arr=array(),$page=1,$size=10){		
		$where = " where 1 ";
		if(isset($arr['user_id'])){
			$where .= " and u.user_id='{$arr['user_id']}' ";
		}
		
		$sql  = "select u.id, s.name as sport_name, s.theme_img  from ".
			  $this->db->dbprefix.$this->table." as u left join ".
			  $this->db->dbprefix."sport as s on u.sid=s.id
			  {$where}
			  GROUP BY u.sid LIMIT ".($page-1)*$size .",{$size}";
				
		$query = $this->db->query($sql);
		$res = $query->result_array();		
		
		$sql  = "select count(*) as num from ".
			  $this->db->dbprefix.$this->table." as u left join ".
			  $this->db->dbprefix."sport as s on u.sid=s.id
			  {$where} ";
		$query = $this->db->query($sql);
		$row = $query->row_array();		
		return array('list'=>$res,'count' =>$row['num']);		
	}
	//全部列表
	function get_lists(){		
		$sql  = "select * from ".$this->db->dbprefix.$this->table;
		$query = $this->db->query($sql);
		$res = $query->result_array();
		return $res;		
	}
	//详情
	function get_info($id,$user_id){
		$where = " where 1 ";
		if(isset($user_id)){
			$where .= " and u.user_id='{$user_id}' ";
		}
		if(isset($id)){			
			$where .= " and u.id='{$id}' ";			
		}
		//var_dump($where);exit;
		
		$sql  = "select u.*, s.name as sport_name, s.theme_img, s.video  from ".
			  $this->db->dbprefix.$this->table." as u left join ".
			  $this->db->dbprefix."sport as s on u.sid=s.id 			 
			 ".$where;
		//var_dump($sql);exit; 
		
		
		$query = $this->db->query($sql);
		$row = $query->row_array();		
		return $row;
	}
	//唯一条件获取详情
	function unique_get_info($field,$value){
		$sql  = "select * from ".$this->db->dbprefix.$this->table." where {$field}='{$value}' ";
		$query = $this->db->query($sql);
		$row = $query->row_array();		
		return $row;
	}
	
}

